Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_APPLY

`ALL_APPLY` displays information about the apply processes that dequeue events from queues accessible to the current user.

Related View

`DBA_APPLY` displays information about all apply processes in the database.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`APPLY_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the apply process
`QUEUE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the queue from which the apply process dequeues
`QUEUE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the queue from which the apply process dequeues
`APPLY_CAPTURED` | `VARCHAR2(3)` |  | Indicates whether the apply process applies captured events (`YES`) or user-enqueued events (`NO`)
`RULE_SET_NAME` | `VARCHAR2(30)` |  | Name of the positive rule set used by the apply process for filtering
`RULE_SET_OWNER` | `VARCHAR2(30)` |  | Owner of the positive rule set used by the apply process for filtering
`APPLY_USER` | `VARCHAR2(30)` |  | User who is applying events
`APPLY_DATABASE_LINK` | `VARCHAR2(128)` |  | Database link to which changes are applied. If null, then changes are applied to the local database.
`APPLY_TAG` | `RAW(2000)` |  | Tag associated with redo log records that are generated when changes are made by the apply process
`DDL_HANDLER` | `VARCHAR2(98)` |  | Name of the user-specified DDL handler, which handles DDL logical change records
`PRECOMMIT_HANDLER` | `VARCHAR2(98)` |  | Name of the user-specified pre-commit handler
`MESSAGE_HANDLER` | `VARCHAR2(98)` |  | Name of the user-specified procedure that handles dequeued events other than logical change records
`STATUS` | `VARCHAR2(8)` |  | Status of the apply process: `DISABLED` `ENABLED` `ABORTED`
`MAX_APPLIED_MESSAGE_NUMBER` | `NUMBER` |  | System change number (SCN) corresponding to the apply process high-watermark for the last time the apply process was stopped using the `DBMS_APPLY_ADM.STOP_APPLY` procedure with the `force` parameter set to `false`. The apply process high-watermark is the SCN beyond which no events have been applied.
`NEGATIVE_RULE_SET_NAME` | `VARCHAR2(30)` |  | Name of the negative rule set used by the apply process for filtering
`NEGATIVE_RULE_SET_OWNER` | `VARCHAR2(30)` |  | Owner of the negative rule set used by the apply process for filtering
`STATUS_CHANGE_TIME` | `DATE` |  | Time that the STATUS of the apply process was changed
`ERROR_NUMBER` | `NUMBER` |  | Error number if the apply process was aborted
`ERROR_MESSAGE` | `VARCHAR2(4000)` |  | Error message if the apply process was aborted

See Also: "DBA_APPLY"